package tw.com.book.componet;

public interface DBContract {
	String CREATE_VOO1 = "CREATE TABLE V001  ("//
			+ "uuid text PRIMARY KEY NOT NULL DEFAULT(' '),"//
			+ "create_time char(6) NOT NULL,"
			+ "create_date char(8) NOT NULL DEFAULT(' '),"
			+ "status char(1) NOT NULL DEFAULT(' '),"
			+ "create_user char(128) NOT NULL DEFAULT(' '),"
			+ "end_time char(6) NOT NULL DEFAULT(' '),"
			+ "end_date char(8) NOT NULL DEFAULT(''),"
			+ "title text NOT NULL"
			+ ");";//

	String CREATE_VOO2 = "CREATE TABLE V002 (" + //
			"uuid text NOT NULL," + //
			"serial_no char(3) NOT NULL," + //
			"content char(200) NOT NULL," + //
			"modify_date char(8) NOT NULL," + //
			"modify_time char(6) NOT NULL," + //
			"PRIMARY KEY(uuid, serial_no)" + //
			")";//

	String CREATE_XOO1 = "CREATE TABLE X001 (" + //
			"email text NOT NULL," + //
			"on_Line_No text NOT NULL," + //
			"password char(20) NOT NULL," + //

			"PRIMARY KEY(email, on_Line_No)" + //
			")";//

	String V001_TABLE = "V001";
	String V002_TABLE = "V002";
	String X001_TABLE = "X001";
}
